{{frmt=html}}{{name=Division Activity}}{{lang=en}}{{cach=hold:15}}
{{ifeq=pdat;{{qstr=sql;select max(divisionName),max(divisionID),count(computerUserSession),count(computerID)-count(computerUserSession),count(computerID),(100*count(computerUserSession))/count(computerID),100-((100*count(computerUserSession))/count(computerID))
from
{oj KSComputers LEFT OUTER JOIN KSComputerDivisions ON computerDivisionID=divisionID AND computerServerID=divisionServerID}
where
(divisionName IS NOT NULL)
group by
divisionName,divisionID}}
}}
{{ifne=pdat;{{qstr=sql;select computerName,computerUserName
from
KSComputers
where
computerDivisionID={{item=pdai}} AND computerUserSession IS NULL
order by
computerName}}
}}
}}
{{ifne=pdat;{{qstr=sql;select computerName,computerUserName
from
KSComputers
where
computerDivisionID={{item=pdai}} AND computerUserSession IS NOT NULL
order by
computerName
}}
{{list=sqls;
{{item=t001}}
}}
}}
Report generated {{item=time}}. All times are GMT{{item=gmto}}.